Pandas Profiling Report

Dataset statistics

Number of variables	23
Number of observations	52
Missing cells	603
Missing cells (%)	50.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	9.5 KiB
Average record size in memory	186.5 B

Variable types

Numeric	14
Unsupported	9

Alerts

`Year` is highly overall correlated with `Natural gas` and 11 other fields	High correlation
`Natural gas` is highly overall correlated with `Year` and 11 other fields	High correlation
`Coal` is highly overall correlated with `Year` and 11 other fields	High correlation
`Hydroenergy` is highly overall correlated with `Year` and 10 other fields	High correlation
`Nuclear` is highly overall correlated with `Year` and 10 other fields	High correlation
`Firewood` is highly overall correlated with `Year` and 9 other fields	High correlation
`Other Primary_x000d_` is highly overall correlated with `Year` and 10 other fields	High correlation
`Total Primaries` is highly overall correlated with `Year` and 11 other fields	High correlation
`Electricity` is highly overall correlated with `Year` and 11 other fields	High correlation
`Diesel oil` is highly overall correlated with `Year` and 8 other fields	High correlation
`Other secondary` is highly overall correlated with `Year` and 9 other fields	High correlation
`Total Secundaries` is highly overall correlated with `Year` and 11 other fields	High correlation
`Total` is highly overall correlated with `Year` and 11 other fields	High correlation
`Oil` has 52 (100.0%) missing values	Missing
`Natural gas` has 18 (34.6%) missing values	Missing
`Nuclear` has 14 (26.9%) missing values	Missing
`Firewood` has 33 (63.5%) missing values	Missing
`Sugarcane and products` has 52 (100.0%) missing values	Missing
`Other Primary_x000d_` has 30 (57.7%) missing values	Missing
`LPG` has 52 (100.0%) missing values	Missing
`Gasoline/alcohol` has 52 (100.0%) missing values	Missing
`Kerosene/jet fuel` has 52 (100.0%) missing values	Missing
`Coke` has 52 (100.0%) missing values	Missing
`Charcoal` has 52 (100.0%) missing values	Missing
`Gases` has 52 (100.0%) missing values	Missing
`Other secondary` has 40 (76.9%) missing values	Missing
`Non-energy` has 52 (100.0%) missing values	Missing
`Year` is uniformly distributed	Uniform
`Year` has unique values	Unique
`Coal` has unique values	Unique
`Hydroenergy` has unique values	Unique
`Total Primaries` has unique values	Unique
`Electricity` has unique values	Unique
`Fuel oil` has unique values	Unique
`Total Secundaries` has unique values	Unique
`Total` has unique values	Unique
`Oil` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Sugarcane and products` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`LPG` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Gasoline/alcohol` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Kerosene/jet fuel` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Coke` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Charcoal` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Gases` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Non-energy` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2023-07-30 07:35:54.129075
Analysis finished	2023-07-30 07:36:41.065819
Duration	46.94 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

Year
Real number (ℝ)

HIGH CORRELATION UNIFORM UNIQUE

Distinct	52
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1995.5

Minimum	1970
Maximum	2021
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	548.0 B

Quantile statistics

Minimum	1970
5-th percentile	1972.55
Q1	1982.75
median	1995.5
Q3	2008.25
95-th percentile	2018.45
Maximum	2021
Range	51
Interquartile range (IQR)	25.5

Descriptive statistics

Standard deviation	15.154757
Coefficient of variation (CV)	0.0075944662
Kurtosis	-1.2
Mean	1995.5
Median Absolute Deviation (MAD)	13
Skewness	0
Sum	103766
Variance	229.66667
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1970	1	1.9%
1971	1	1.9%
1998	1	1.9%
1999	1	1.9%
2000	1	1.9%
2001	1	1.9%
2002	1	1.9%
2003	1	1.9%
2004	1	1.9%
2005	1	1.9%
Other values (42)	42	80.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1970	1	1.9%
1971	1	1.9%
1972	1	1.9%
1973	1	1.9%
1974	1	1.9%
1975	1	1.9%
1976	1	1.9%
1977	1	1.9%
1978	1	1.9%
1979	1	1.9%

Value	Count	Frequency (%)
2021	1	1.9%
2020	1	1.9%
2019	1	1.9%
2018	1	1.9%
2017	1	1.9%
2016	1	1.9%
2015	1	1.9%
2014	1	1.9%
2013	1	1.9%
2012	1	1.9%

Oil
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	52
Missing (%)	100.0%
Memory size	548.0 B

Natural gas
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	32
Distinct (%)	94.1%
Missing	18
Missing (%)	34.6%
Infinite	0
Infinite (%)	0.0%
Mean	-3927.8979

Minimum	-14183.44
Maximum	-0.85
Zeros	0
Zeros (%)	0.0%
Negative	34
Negative (%)	65.4%
Memory size	548.0 B

Quantile statistics

Minimum	-14183.44
5-th percentile	-13376.969
Q1	-7516.0375
median	-2007.99
Q3	-31.3775
95-th percentile	-1.669
Maximum	-0.85
Range	14182.59
Interquartile range (IQR)	7484.66

Descriptive statistics

Standard deviation	4618.947
Coefficient of variation (CV)	-1.1759336
Kurtosis	-0.28792389
Mean	-3927.8979
Median Absolute Deviation (MAD)	2002.475
Skewness	-1.015186
Sum	-133548.53
Variance	21334671
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
-0.85	2	3.8%
-7.64	2	3.8%
-14183.44	1	1.9%
-1569.67	1	1.9%
-4806.51	1	1.9%
-2889.8	1	1.9%
-6682.24	1	1.9%
-11543.61	1	1.9%
-8717.87	1	1.9%
-13670.34	1	1.9%
Other values (22)	22	42.3%
(Missing)	18	34.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-14183.44	1	1.9%
-13670.34	1	1.9%
-13219	1	1.9%
-11543.61	1	1.9%
-10325.21	1	1.9%
-9362.71	1	1.9%
-8717.87	1	1.9%
-8069.18	1	1.9%
-7793.97	1	1.9%
-6682.24	1	1.9%

Value	Count	Frequency (%)
-0.85	2	3.8%
-2.11	1	1.9%
-4.79	1	1.9%
-5.09	1	1.9%
-5.94	1	1.9%
-7.64	2	3.8%
-27.21	1	1.9%
-43.88	1	1.9%
-73.69	1	1.9%
-107.83	1	1.9%

Coal
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	52
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-1721.7685

Minimum	-4253.56
Maximum	-401.51
Zeros	0
Zeros (%)	0.0%
Negative	52
Negative (%)	100.0%
Memory size	548.0 B

Quantile statistics

Minimum	-4253.56
5-th percentile	-4018.411
Q1	-2077.7775
median	-1525.495
Q3	-834.5475
95-th percentile	-436.4195
Maximum	-401.51
Range	3852.05
Interquartile range (IQR)	1243.23

Descriptive statistics

Standard deviation	1132.28
Coefficient of variation (CV)	-0.65762615
Kurtosis	-0.30795057
Mean	-1721.7685
Median Absolute Deviation (MAD)	657.535
Skewness	-0.86288362
Sum	-89531.96
Variance	1282057.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-454.51	1	1.9%
-473.18	1	1.9%
-1444.42	1	1.9%
-3242.64	1	1.9%
-3294.6	1	1.9%
-3264.65	1	1.9%
-1463.27	1	1.9%
-1535.82	1	1.9%
-1717.8	1	1.9%
-1832.46	1	1.9%
Other values (42)	42	80.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-4253.56	1	1.9%
-4189.67	1	1.9%
-4129.61	1	1.9%
-3927.43	1	1.9%
-3559.56	1	1.9%
-3544.06	1	1.9%
-3329.31	1	1.9%
-3294.6	1	1.9%
-3264.65	1	1.9%
-3242.64	1	1.9%

Value	Count	Frequency (%)
-401.51	1	1.9%
-412.71	1	1.9%
-426.03	1	1.9%
-444.92	1	1.9%
-454.51	1	1.9%
-473.18	1	1.9%
-504.88	1	1.9%
-518.12	1	1.9%
-638.73	1	1.9%
-657.23	1	1.9%

Hydroenergy
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	52
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-20518.364

Minimum	-34796.89
Maximum	-3302.28
Zeros	0
Zeros (%)	0.0%
Negative	52
Negative (%)	100.0%
Memory size	548.0 B

Quantile statistics

Minimum	-34796.89
5-th percentile	-32634.977
Q1	-29847.658
median	-22002.94
Q3	-12549.71
95-th percentile	-4566.1605
Maximum	-3302.28
Range	31494.61
Interquartile range (IQR)	17297.948

Descriptive statistics

Standard deviation	9638.1209
Coefficient of variation (CV)	-0.46973145
Kurtosis	-1.1949485
Mean	-20518.364
Median Absolute Deviation (MAD)	8175.955
Skewness	0.2911697
Sum	-1066954.9
Variance	92893374
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-3302.28	1	1.9%
-3599.12	1	1.9%
-24559.29	1	1.9%
-24699.38	1	1.9%
-25666.15	1	1.9%
-22580.15	1	1.9%
-23528.41	1	1.9%
-25238.2	1	1.9%
-26472.41	1	1.9%
-27885.2	1	1.9%
Other values (42)	42	80.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-34796.89	1	1.9%
-33976.84	1	1.9%
-32821.95	1	1.9%
-32482	1	1.9%
-32465.96	1	1.9%
-31884.36	1	1.9%
-31744.82	1	1.9%
-31710.29	1	1.9%
-30840.26	1	1.9%
-30819.43	1	1.9%

Value	Count	Frequency (%)
-3302.28	1	1.9%
-3599.12	1	1.9%
-4232.69	1	1.9%
-4839	1	1.9%
-5500.16	1	1.9%
-6050.86	1	1.9%
-6935.88	1	1.9%
-7812.81	1	1.9%
-8596.22	1	1.9%
-9795.95	1	1.9%

Nuclear
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	38
Distinct (%)	100.0%
Missing	14
Missing (%)	26.9%
Infinite	0
Infinite (%)	0.0%
Mean	-2129.1611

Minimum	-4203.27
Maximum	-2.58
Zeros	0
Zeros (%)	0.0%
Negative	38
Negative (%)	73.1%
Memory size	548.0 B

Quantile statistics

Minimum	-4203.27
5-th percentile	-4141.144
Q1	-3821.7375
median	-3121.63
Q3	-92.4125
95-th percentile	-14.395
Maximum	-2.58
Range	4200.69
Interquartile range (IQR)	3729.325

Descriptive statistics

Standard deviation	1834.2937
Coefficient of variation (CV)	-0.86151009
Kurtosis	-1.944345
Mean	-2129.1611
Median Absolute Deviation (MAD)	1035.39
Skewness	0.18628677
Sum	-80908.12
Variance	3364633.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
-4179.7	1	1.9%
-2482.01	1	1.9%
-3581.88	1	1.9%
-3213.03	1	1.9%
-3640.71	1	1.9%
-3376.67	1	1.9%
-3779.7	1	1.9%
-4080.93	1	1.9%
-4026.28	1	1.9%
-3436.73	1	1.9%
Other values (28)	28	53.8%
(Missing)	14	26.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-4203.27	1	1.9%
-4179.7	1	1.9%
-4134.34	1	1.9%
-4101.73	1	1.9%
-4084.71	1	1.9%
-4080.93	1	1.9%
-4026.28	1	1.9%
-4007.72	1	1.9%
-3839.81	1	1.9%
-3835.75	1	1.9%

Value	Count	Frequency (%)
-2.58	1	1.9%
-4.28	1	1.9%
-16.18	1	1.9%
-18.75	1	1.9%
-30.77	1	1.9%
-39.98	1	1.9%
-46.77	1	1.9%
-54.71	1	1.9%
-68.81	1	1.9%
-90.15	1	1.9%

Firewood
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	19
Distinct (%)	100.0%
Missing	33
Missing (%)	63.5%
Infinite	0
Infinite (%)	0.0%
Mean	-43.737895

Minimum	-71.39
Maximum	-1.55
Zeros	0
Zeros (%)	0.0%
Negative	19
Negative (%)	36.5%
Memory size	548.0 B

Quantile statistics

Minimum	-71.39
5-th percentile	-69.059
Q1	-64.87
median	-45.55
Q3	-26.185
95-th percentile	-6.851
Maximum	-1.55
Range	69.84
Interquartile range (IQR)	38.685

Descriptive statistics

Standard deviation	22.725883
Coefficient of variation (CV)	-0.51959251
Kurtosis	-1.1191833
Mean	-43.737895
Median Absolute Deviation (MAD)	20.03
Skewness	0.46869152
Sum	-831.02
Variance	516.46574
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
-1.55	1	1.9%
-65.58	1	1.9%
-71.39	1	1.9%
-68.8	1	1.9%
-63.25	1	1.9%
-43.14	1	1.9%
-65.73	1	1.9%
-67.72	1	1.9%
-64.16	1	1.9%
-44.97	1	1.9%
Other values (9)	9	17.3%
(Missing)	33	63.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-71.39	1	1.9%
-68.8	1	1.9%
-67.72	1	1.9%
-65.73	1	1.9%
-65.58	1	1.9%
-64.16	1	1.9%
-63.25	1	1.9%
-56.11	1	1.9%
-48.86	1	1.9%
-45.55	1	1.9%

Value	Count	Frequency (%)
-1.55	1	1.9%
-7.44	1	1.9%
-13.92	1	1.9%
-18.87	1	1.9%
-23.24	1	1.9%
-29.13	1	1.9%
-31.61	1	1.9%
-43.14	1	1.9%
-44.97	1	1.9%
-45.55	1	1.9%

Sugarcane and products
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	52
Missing (%)	100.0%
Memory size	548.0 B

Other Primary_x000d_
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	21
Distinct (%)	95.5%
Missing	30
Missing (%)	57.7%
Infinite	0
Infinite (%)	0.0%
Mean	-1595.23

Minimum	-7138.42
Maximum	-1
Zeros	0
Zeros (%)	0.0%
Negative	22
Negative (%)	42.3%
Memory size	548.0 B

Quantile statistics

Minimum	-7138.42
5-th percentile	-5668.1225
Q1	-2772.4675
median	-241.815
Q3	-22.3075
95-th percentile	-10.248
Maximum	-1
Range	7137.42
Interquartile range (IQR)	2750.16

Descriptive statistics

Standard deviation	2281.8065
Coefficient of variation (CV)	-1.4303934
Kurtosis	0.34828257
Mean	-1595.23
Median Absolute Deviation (MAD)	236.315
Skewness	-1.3052396
Sum	-35095.06
Variance	5206640.9
Monotonicity	Decreasing

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
-14.99	2	3.8%
-520.89	1	1.9%
-5676.99	1	1.9%
-5499.64	1	1.9%
-4620.22	1	1.9%
-3895.16	1	1.9%
-3028.94	1	1.9%
-2003.05	1	1.9%
-1166.92	1	1.9%
-625.21	1	1.9%
Other values (11)	11	21.2%
(Missing)	30	57.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-7138.42	1	1.9%
-5676.99	1	1.9%
-5499.64	1	1.9%
-4620.22	1	1.9%
-3895.16	1	1.9%
-3028.94	1	1.9%
-2003.05	1	1.9%
-1166.92	1	1.9%
-625.21	1	1.9%
-520.89	1	1.9%

Value	Count	Frequency (%)
-1	1	1.9%
-10	1	1.9%
-14.96	1	1.9%
-14.99	2	3.8%
-18.22	1	1.9%
-34.57	1	1.9%
-62.92	1	1.9%
-113.01	1	1.9%
-151.33	1	1.9%
-193.51	1	1.9%

Total Primaries
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	52
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-27055.185

Minimum	-58191.16
Maximum	-3756.79
Zeros	0
Zeros (%)	0.0%
Negative	52
Negative (%)	100.0%
Memory size	548.0 B

Quantile statistics

Minimum	-58191.16
5-th percentile	-53243.743
Q1	-38955.067
median	-23933.925
Q3	-13257.922
95-th percentile	-5038.058
Maximum	-3756.79
Range	54434.37
Interquartile range (IQR)	25697.145

Descriptive statistics

Standard deviation	16456.813
Coefficient of variation (CV)	-0.60826837
Kurtosis	-1.1170165
Mean	-27055.185
Median Absolute Deviation (MAD)	12802.6
Skewness	-0.35626266
Sum	-1406869.6
Variance	2.7082669 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-3756.79	1	1.9%
-4072.3	1	1.9%
-26214.28	1	1.9%
-28210.58	1	1.9%
-31035.11	1	1.9%
-30864.56	1	1.9%
-30528.71	1	1.9%
-31978.29	1	1.9%
-34253.78	1	1.9%
-35119	1	1.9%
Other values (42)	42	80.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-58191.16	1	1.9%
-54932.27	1	1.9%
-53689.38	1	1.9%
-52879.13	1	1.9%
-52286.06	1	1.9%
-52153.23	1	1.9%
-51599.49	1	1.9%
-51563.65	1	1.9%
-50691.99	1	1.9%
-47580.88	1	1.9%

Value	Count	Frequency (%)
-3756.79	1	1.9%
-4072.3	1	1.9%
-4737.56	1	1.9%
-5283.92	1	1.9%
-5926.2	1	1.9%
-6463.57	1	1.9%
-7337.38	1	1.9%
-8330.93	1	1.9%
-9480.13	1	1.9%
-10530.65	1	1.9%

Electricity
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	52
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23961.181

Minimum	3613.39
Maximum	46508.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	548.0 B

Quantile statistics

Minimum	3613.39
5-th percentile	4906.9575
Q1	12936.685
median	22951.87
Q3	35161.013
95-th percentile	43475.643
Maximum	46508.5
Range	42895.11
Interquartile range (IQR)	22224.328

Descriptive statistics

Standard deviation	13081.425
Coefficient of variation (CV)	0.5459424
Kurtosis	-1.2132818
Mean	23961.181
Median Absolute Deviation (MAD)	11309.015
Skewness	0.13521297
Sum	1245981.4
Variance	1.7112367 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3613.39	1	1.9%
4112.59	1	1.9%
25829.2	1	1.9%
26707.88	1	1.9%
27844.17	1	1.9%
25902.98	1	1.9%
26724.24	1	1.9%
28240.64	1	1.9%
29985.81	1	1.9%
31156.29	1	1.9%
Other values (42)	42	80.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3613.39	1	1.9%
4112.59	1	1.9%
4564.17	1	1.9%
5187.42	1	1.9%
5768.89	1	1.9%
6350.11	1	1.9%
7266.76	1	1.9%
8173.78	1	1.9%
9106.34	1	1.9%
10223.54	1	1.9%

Value	Count	Frequency (%)
46508.5	1	1.9%
44947.39	1	1.9%
44163.05	1	1.9%
42913.22	1	1.9%
42721.55	1	1.9%
42133.96	1	1.9%
41721.75	1	1.9%
41633.34	1	1.9%
41208.58	1	1.9%
40825.1	1	1.9%

LPG
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	52
Missing (%)	100.0%
Memory size	548.0 B

Gasoline/alcohol
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	52
Missing (%)	100.0%
Memory size	548.0 B

Kerosene/jet fuel
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	52
Missing (%)	100.0%
Memory size	548.0 B

Diesel oil
Real number (ℝ)

Distinct	51
Distinct (%)	98.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-898.22115

Minimum	-2907.78
Maximum	-111.45
Zeros	0
Zeros (%)	0.0%
Negative	52
Negative (%)	100.0%
Memory size	548.0 B

Quantile statistics

Minimum	-2907.78
5-th percentile	-2131.1435
Q1	-1353.0175
median	-825.85
Q3	-297.8725
95-th percentile	-118.783
Maximum	-111.45
Range	2796.33
Interquartile range (IQR)	1055.145

Descriptive statistics

Standard deviation	675.92556
Coefficient of variation (CV)	-0.75251575
Kurtosis	0.26229556
Mean	-898.22115
Median Absolute Deviation (MAD)	528.575
Skewness	-0.8315191
Sum	-46707.5
Variance	456875.37
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-119.17	2	3.8%
-115.74	1	1.9%
-1357.24	1	1.9%
-1660.58	1	1.9%
-1186.85	1	1.9%
-1210.44	1	1.9%
-1074.01	1	1.9%
-1351.61	1	1.9%
-1671.63	1	1.9%
-1761.5	1	1.9%
Other values (41)	41	78.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-2907.78	1	1.9%
-2345.34	1	1.9%
-2257.77	1	1.9%
-2027.54	1	1.9%
-1778.08	1	1.9%
-1761.5	1	1.9%
-1671.63	1	1.9%
-1660.58	1	1.9%
-1656.82	1	1.9%
-1593.12	1	1.9%

Value	Count	Frequency (%)
-111.45	1	1.9%
-115.74	1	1.9%
-118.31	1	1.9%
-119.17	2	3.8%
-124.31	1	1.9%
-137.17	1	1.9%
-148.32	1	1.9%
-167.18	1	1.9%
-246.57	1	1.9%
-264.91	1	1.9%

Fuel oil
Real number (ℝ)

Distinct	52
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-848.87038

Minimum	-3313.85
Maximum	-265.93
Zeros	0
Zeros (%)	0.0%
Negative	52
Negative (%)	100.0%
Memory size	548.0 B

Quantile statistics

Minimum	-3313.85
5-th percentile	-1810.5565
Q1	-1021.4175
median	-630.795
Q3	-423.525
95-th percentile	-274.6555
Maximum	-265.93
Range	3047.92
Interquartile range (IQR)	597.8925

Descriptive statistics

Standard deviation	631.09023
Coefficient of variation (CV)	-0.74344711
Kurtosis	5.464735
Mean	-848.87038
Median Absolute Deviation (MAD)	268.49
Skewness	-2.1270271
Sum	-44141.26
Variance	398274.88
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-652.61	1	1.9%
-1118.36	1	1.9%
-785.01	1	1.9%
-1421.45	1	1.9%
-1615.37	1	1.9%
-1640.98	1	1.9%
-1019.45	1	1.9%
-544.68	1	1.9%
-284.5	1	1.9%
-415.37	1	1.9%
Other values (42)	42	80.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-3313.85	1	1.9%
-2981.73	1	1.9%
-1967.62	1	1.9%
-1682.05	1	1.9%
-1656.49	1	1.9%
-1640.98	1	1.9%
-1615.37	1	1.9%
-1421.45	1	1.9%
-1375.41	1	1.9%
-1169.42	1	1.9%

Value	Count	Frequency (%)
-265.93	1	1.9%
-270.73	1	1.9%
-272.45	1	1.9%
-276.46	1	1.9%
-284.5	1	1.9%
-284.73	1	1.9%
-333.78	1	1.9%
-337.01	1	1.9%
-340.27	1	1.9%
-342.67	1	1.9%

Coke
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	52
Missing (%)	100.0%
Memory size	548.0 B

Charcoal
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	52
Missing (%)	100.0%
Memory size	548.0 B

Gases
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	52
Missing (%)	100.0%
Memory size	548.0 B

Other secondary
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	12
Distinct (%)	100.0%
Missing	40
Missing (%)	76.9%
Infinite	0
Infinite (%)	0.0%
Mean	-70.098333

Minimum	-137.32
Maximum	-0.01
Zeros	0
Zeros (%)	0.0%
Negative	12
Negative (%)	23.1%
Memory size	548.0 B

Quantile statistics

Minimum	-137.32
5-th percentile	-107.4495
Q1	-79.615
median	-75.14
Q3	-67.1925
95-th percentile	-20.3215
Maximum	-0.01
Range	137.31
Interquartile range (IQR)	12.4225

Descriptive statistics

Standard deviation	32.067451
Coefficient of variation (CV)	-0.45746382
Kurtosis	2.8076888
Mean	-70.098333
Median Absolute Deviation (MAD)	5.51
Skewness	0.25451691
Sum	-841.18
Variance	1028.3214
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
-0.01	1	1.9%
-36.94	1	1.9%
-52.86	1	1.9%
-75.29	1	1.9%
-78.58	1	1.9%
-74.99	1	1.9%
-72.19	1	1.9%
-83.01	1	1.9%
-82.72	1	1.9%
-137.32	1	1.9%
Other values (2)	2	3.8%
(Missing)	40	76.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-137.32	1	1.9%
-83.01	1	1.9%
-82.72	1	1.9%
-78.58	1	1.9%
-75.3	1	1.9%
-75.29	1	1.9%
-74.99	1	1.9%
-72.19	1	1.9%
-71.97	1	1.9%
-52.86	1	1.9%

Value	Count	Frequency (%)
-0.01	1	1.9%
-36.94	1	1.9%
-52.86	1	1.9%
-71.97	1	1.9%
-72.19	1	1.9%
-74.99	1	1.9%
-75.29	1	1.9%
-75.3	1	1.9%
-78.58	1	1.9%
-82.72	1	1.9%

Non-energy
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	52
Missing (%)	100.0%
Memory size	548.0 B

Total Secundaries
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	52
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23961.181

Minimum	3613.39
Maximum	46508.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	548.0 B

Quantile statistics

Minimum	3613.39
5-th percentile	4906.9575
Q1	12936.685
median	22951.87
Q3	35161.013
95-th percentile	43475.643
Maximum	46508.5
Range	42895.11
Interquartile range (IQR)	22224.328

Descriptive statistics

Standard deviation	13081.425
Coefficient of variation (CV)	0.5459424
Kurtosis	-1.2132818
Mean	23961.181
Median Absolute Deviation (MAD)	11309.015
Skewness	0.13521297
Sum	1245981.4
Variance	1.7112367 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3613.39	1	1.9%
4112.59	1	1.9%
25829.2	1	1.9%
26707.88	1	1.9%
27844.17	1	1.9%
25902.98	1	1.9%
26724.24	1	1.9%
28240.64	1	1.9%
29985.81	1	1.9%
31156.29	1	1.9%
Other values (42)	42	80.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3613.39	1	1.9%
4112.59	1	1.9%
4564.17	1	1.9%
5187.42	1	1.9%
5768.89	1	1.9%
6350.11	1	1.9%
7266.76	1	1.9%
8173.78	1	1.9%
9106.34	1	1.9%
10223.54	1	1.9%

Value	Count	Frequency (%)
46508.5	1	1.9%
44947.39	1	1.9%
44163.05	1	1.9%
42913.22	1	1.9%
42721.55	1	1.9%
42133.96	1	1.9%
41721.75	1	1.9%
41633.34	1	1.9%
41208.58	1	1.9%
40825.1	1	1.9%

Total
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	52
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-4857.2712

Minimum	-17268.03
Maximum	-741.46
Zeros	0
Zeros (%)	0.0%
Negative	52
Negative (%)	100.0%
Memory size	548.0 B

Quantile statistics

Minimum	-17268.03
5-th percentile	-14528.755
Q1	-7065.0925
median	-2289.18
Q3	-1171.415
95-th percentile	-852.955
Maximum	-741.46
Range	16526.57
Interquartile range (IQR)	5893.6775

Descriptive statistics

Standard deviation	4611.7298
Coefficient of variation (CV)	-0.94944871
Kurtosis	0.3244992
Mean	-4857.2712
Median Absolute Deviation (MAD)	1436.91
Skewness	-1.1333041
Sum	-252578.1
Variance	21268052
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-911.74	1	1.9%
-1189.52	1	1.9%
-2411.4	1	1.9%
-4584.74	1	1.9%
-5993.15	1	1.9%
-7813	1	1.9%
-5897.93	1	1.9%
-5633.93	1	1.9%
-6224.1	1	1.9%
-6139.58	1	1.9%
Other values (42)	42	80.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-17268.03	1	1.9%
-16241.63	1	1.9%
-14785.66	1	1.9%
-14318.56	1	1.9%
-12106.84	1	1.9%
-11514.7	1	1.9%
-11499.83	1	1.9%
-10378.08	1	1.9%
-10093.73	1	1.9%
-9548.89	1	1.9%

Value	Count	Frequency (%)
-741.46	1	1.9%
-825.95	1	1.9%
-845.42	1	1.9%
-859.12	1	1.9%
-870.29	1	1.9%
-892.7	1	1.9%
-903.3	1	1.9%
-911.74	1	1.9%
-933.81	1	1.9%
-1009.15	1	1.9%

Auto

Heatmap
Table

	Year	Natural gas	Coal	Hydroenergy	Nuclear	Firewood	Other Primary_x000d_	Total Primaries	Electricity	Diesel oil	Fuel oil	Other secondary	Total Secundaries	Total
Year	1.000	-0.937	-0.916	-0.969	-0.903	-0.746	-1.000	-0.997	0.999	-0.865	-0.288	-0.622	0.999	-0.949
Natural gas	-0.937	1.000	0.749	0.797	0.896	0.696	0.833	0.954	-0.944	0.644	0.467	0.636	-0.944	0.958
Coal	-0.916	0.749	1.000	0.860	0.736	0.716	0.577	0.925	-0.919	0.824	0.377	0.503	-0.919	0.936
Hydroenergy	-0.969	0.797	0.860	1.000	0.857	0.319	0.617	0.965	-0.969	0.889	0.253	-0.566	-0.969	0.909
Nuclear	-0.903	0.896	0.736	0.857	1.000	0.512	0.727	0.899	-0.896	0.638	0.340	0.378	-0.896	0.895
Firewood	-0.746	0.696	0.716	0.319	0.512	1.000	0.571	0.798	-0.802	0.477	0.282	0.769	-0.802	0.746
Other Primary_x000d_\n	-1.000	0.833	0.577	0.617	0.727	0.571	1.000	0.961	-0.985	-0.190	0.074	0.622	-0.985	0.796
Total Primaries	-0.997	0.954	0.925	0.965	0.899	0.798	0.961	1.000	-0.999	0.883	0.306	0.720	-0.999	0.955
Electricity	0.999	-0.944	-0.919	-0.969	-0.896	-0.802	-0.985	-0.999	1.000	-0.875	-0.292	-0.734	1.000	-0.951
Diesel oil	-0.865	0.644	0.824	0.889	0.638	0.477	-0.190	0.883	-0.875	1.000	0.374	-0.287	-0.875	0.869
Fuel oil	-0.288	0.467	0.377	0.253	0.340	0.282	0.074	0.306	-0.292	0.374	1.000	0.147	-0.292	0.470
Other secondary	-0.622	0.636	0.503	-0.566	0.378	0.769	0.622	0.720	-0.734	-0.287	0.147	1.000	-0.734	0.580
Total Secundaries	0.999	-0.944	-0.919	-0.969	-0.896	-0.802	-0.985	-0.999	1.000	-0.875	-0.292	-0.734	1.000	-0.951
Total	-0.949	0.958	0.936	0.909	0.895	0.746	0.796	0.955	-0.951	0.869	0.470	0.580	-0.951	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

395	Year	Oil	Natural gas	Coal	Hydroenergy	Nuclear	Firewood	Sugarcane and products	Other Primary_x000d_	Total Primaries	Electricity	LPG	Gasoline/alcohol	Kerosene/jet fuel	Diesel oil	Fuel oil	Coke	Charcoal	Gases	Other secondary	Non-energy	Total Secundaries	Total
1	1970	NaN	NaN	-454.51	-3302.28	NaN	NaN	NaN	NaN	-3756.79	3613.39	NaN	NaN	NaN	-115.74	-652.61	NaN	NaN	NaN	NaN	NaN	3613.39	-911.74
2	1971	NaN	NaN	-473.18	-3599.12	NaN	NaN	NaN	NaN	-4072.30	4112.59	NaN	NaN	NaN	-111.45	-1118.36	NaN	NaN	NaN	NaN	NaN	4112.59	-1189.52
3	1972	NaN	NaN	-504.88	-4232.69	NaN	NaN	NaN	NaN	-4737.56	4564.17	NaN	NaN	NaN	-119.17	-600.14	NaN	NaN	NaN	NaN	NaN	4564.17	-892.70
4	1973	NaN	NaN	-444.92	-4839.00	NaN	NaN	NaN	NaN	-5283.92	5187.42	NaN	NaN	NaN	-118.31	-815.53	NaN	NaN	NaN	NaN	NaN	5187.42	-1030.34
5	1974	NaN	NaN	-426.03	-5500.16	NaN	NaN	NaN	NaN	-5926.20	5768.89	NaN	NaN	NaN	-119.17	-582.65	NaN	NaN	NaN	NaN	NaN	5768.89	-859.12
6	1975	NaN	NaN	-412.71	-6050.86	NaN	NaN	NaN	NaN	-6463.57	6350.11	NaN	NaN	NaN	-124.31	-588.18	NaN	NaN	NaN	NaN	NaN	6350.11	-825.95
7	1976	NaN	NaN	-401.51	-6935.88	NaN	NaN	NaN	NaN	-7337.38	7266.76	NaN	NaN	NaN	-148.32	-522.52	NaN	NaN	NaN	NaN	NaN	7266.76	-741.46
8	1977	NaN	NaN	-518.12	-7812.81	NaN	NaN	NaN	NaN	-8330.93	8173.78	NaN	NaN	NaN	-137.17	-608.98	NaN	NaN	NaN	NaN	NaN	8173.78	-903.30
9	1978	NaN	NaN	-883.91	-8596.22	NaN	NaN	NaN	NaN	-9480.13	9106.34	NaN	NaN	NaN	-167.18	-753.71	NaN	NaN	NaN	NaN	NaN	9106.34	-1294.68
10	1979	NaN	NaN	-734.70	-9795.95	NaN	NaN	NaN	NaN	-10530.65	10223.54	NaN	NaN	NaN	-264.91	-545.08	NaN	NaN	NaN	NaN	NaN	10223.54	-1117.10

395	Year	Oil	Natural gas	Coal	Hydroenergy	Nuclear	Firewood	Sugarcane and products	Other Primary_x000d_	Total Primaries	Electricity	LPG	Gasoline/alcohol	Kerosene/jet fuel	Diesel oil	Fuel oil	Coke	Charcoal	Gases	Other secondary	Non-energy	Total Secundaries	Total
43	2012	NaN	-6682.24	-2176.23	-33976.84	-4179.70	-44.97	NaN	-520.89	-47580.88	40825.10	NaN	NaN	NaN	-2257.77	-1027.32	NaN	NaN	NaN	-52.86	NaN	40825.10	-10093.73
44	2013	NaN	-11543.61	-3559.56	-31744.82	-4026.28	-64.16	NaN	-625.21	-51563.65	41633.34	NaN	NaN	NaN	-2345.34	-1967.62	NaN	NaN	NaN	-75.29	NaN	41633.34	-14318.56
45	2014	NaN	-14183.44	-4129.61	-30133.97	-4007.72	-67.72	NaN	-1166.92	-53689.38	42721.55	NaN	NaN	NaN	-2907.78	-3313.85	NaN	NaN	NaN	-78.58	NaN	42721.55	-17268.03
46	2015	NaN	-13670.34	-4253.56	-29046.64	-3839.81	-65.73	NaN	-2003.05	-52879.13	41721.75	NaN	NaN	NaN	-2027.54	-2981.73	NaN	NaN	NaN	-74.99	NaN	41721.75	-16241.63
47	2016	NaN	-8717.87	-3927.43	-30840.26	-4134.34	-43.14	NaN	-3028.94	-50691.99	41208.58	NaN	NaN	NaN	-831.65	-1127.44	NaN	NaN	NaN	-72.19	NaN	41208.58	-11514.70
48	2017	NaN	-10325.21	-3544.06	-30223.82	-4101.73	-63.25	NaN	-3895.16	-52153.23	42133.96	NaN	NaN	NaN	-629.15	-1375.41	NaN	NaN	NaN	-83.01	NaN	42133.96	-12106.84
49	2018	NaN	-8069.18	-3046.29	-31710.29	-4084.71	-68.80	NaN	-4620.22	-51599.49	42913.22	NaN	NaN	NaN	-891.36	-717.72	NaN	NaN	NaN	-82.72	NaN	42913.22	-10378.08
50	2019	NaN	-9362.71	-3329.31	-32465.96	-4203.27	-71.39	NaN	-5499.64	-54932.27	44947.39	NaN	NaN	NaN	-1111.70	-265.93	NaN	NaN	NaN	-137.32	NaN	44947.39	-11499.83
51	2020	NaN	-7793.97	-2601.86	-32482.00	-3665.67	-65.58	NaN	-5676.99	-52286.06	44163.05	NaN	NaN	NaN	-1069.18	-284.73	NaN	NaN	NaN	-71.97	NaN	44163.05	-9548.89
52	2021	NaN	-13219.00	-4189.67	-29752.22	-3835.75	-56.11	NaN	-7138.42	-58191.16	46508.50	NaN	NaN	NaN	-1371.21	-1656.49	NaN	NaN	NaN	-75.30	NaN	46508.50	-14785.66

Overview

Variables

Interactions

Correlations

Missing values

Sample